Counts of aircraft noise complaints by community and by month. The Aircraft Noise Abatement Office collects this data via the Complaint Hotline, Online Complaint Form, emails, letters and telephone calls to our office. This information is collected and published in a monthly report which is presented at the SFO Airport Community Roundtable meetings. It is used to understand community's aircraft noise concerns, to collaborate with stakeholders in an effort to reduce and manage aircraft noise.

##   Year Month   Community Total.Complaints Total.Number.of.Callers
## 1 2018     2 San Leandro                1                       1
## 2 2018     4  San Carlos               64                       2
## 3 2018     6  El Granada              475                       1
## 4 2018     4 Santa Clara               15                       1
## 5 2018     8   Los Altos            25681                     163
## 6 2018     6   Palo Alto            48093                     239

The dataset contains values from 2005 to 2018.

• remove incomplete rows (only one row)
• all community names are converted to lower case
• the name South San Franciscio is converted to South San Francisco
• communities with less than 5% of the call

Aircraft Noise Complaint Data: https://data.sfgov.org/Transportation/Aircraft-Noise-Complaint-Data/q3xd-hfi8
Geographic data: https://data.ca.gov/dataset/ca-geographic-boundaries